# mysql-snmp: cacti2MIB.pl
#
# This file contains the mapping from MySQL cacti templates to the MIB names, value and
# and types. This file is used to generate the opennms configuration.
#
# (c) Copryright 2009 - Brice Figureau
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.    See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.

{   name        => 'Cacti 2 MIB',
    short_names => {
        'Key_read_requests'         => {mib => 'myKeyReadRequests',             order => 1,   type => 'Counter32'},
        'Key_reads'                 => {mib => 'myKeyReads',                    order => 2,   type => 'Counter32'},
        'Key_write_requests'        => {mib => 'myKeyWriteRequests',            order => 3,   type => 'Counter32'},
        'Key_writes'                => {mib => 'myKeyWrites',                   order => 4,   type => 'Counter32'},
        'history_list'              => {mib => 'myHistoryList',                 order => 5,   type => 'Gauge32'},
        'innodb_transactions'       => {mib => 'myInnodbTransactions',          order => 6,   type => 'Counter64'},
        'read_views'                => {mib => 'myReadViews',                   order => 7,   type => 'Gauge32'},
        'current_transactions'      => {mib => 'myCurrentTransactions',         order => 8,   type => 'Gauge32'},
        'locked_transactions'       => {mib => 'myLockedTransactions',          order => 9,   type => 'Gauge32'},
        'active_transactions'       => {mib => 'myActiveTransactions',          order => 10,  type => 'Gauge32'},
        'pool_size'                 => {mib => 'myPoolSize',                    order => 11,  type => 'Gauge32'},
        'free_pages'                => {mib => 'myFreePages',                   order => 12,  type => 'Gauge32'},
        'database_pages'            => {mib => 'myDatabasePages',               order => 13,  type => 'Gauge32'},
        'modified_pages'            => {mib => 'myModifiedPages',               order => 14,  type => 'Gauge32'},
        'pages_read'                => {mib => 'myPagesRead',                   order => 15,  type => 'Counter32'},
        'pages_created'             => {mib => 'myPagesCreated',                order => 16,  type => 'Counter32'},
        'pages_written'             => {mib => 'myPagesWritten',                order => 17,  type => 'Counter32'},
        'file_fsyncs'               => {mib => 'myFileFsyncs',                  order => 18,  type => 'Counter32'},
        'file_reads'                => {mib => 'myFileReads',                   order => 19,  type => 'Counter32'},
        'file_writes'               => {mib => 'myFileWrites',                  order => 20,  type => 'Counter32'},
        'log_writes'                => {mib => 'myLogWrites',                   order => 21,  type => 'Counter32'},
        'pending_aio_log_ios'       => {mib => 'myPendingAIOLogIOs',            order => 22,  type => 'Gauge32'},
        'pending_aio_sync_ios'      => {mib => 'myPendingAIOSyncIOs',           order => 23,  type => 'Gauge32'},
        'pending_buf_pool_flushes'  => {mib => 'myPendingBufPoolFlushes',       order => 24,  type => 'Gauge32'},
        'pending_chkp_writes'       => {mib => 'myPendingChkpWrites',           order => 25,  type => 'Gauge32'},
        'pending_ibuf_aio_reads'    => {mib => 'myPendingIbufAIOReads',         order => 26,  type => 'Gauge32'},
        'pending_log_flushes'       => {mib => 'myPendingLogFlushes',           order => 27,  type => 'Gauge32'},
        'pending_log_writes'        => {mib => 'myPendingLogWrites',            order => 28,  type => 'Gauge32'},
        'pending_normal_aio_reads'  => {mib => 'myPendingNormalAIOReads',       order => 29,  type => 'Gauge32'},
        'pending_normal_aio_writes' => {mib => 'myPendingNormalAIOWrites',      order => 30,  type => 'Gauge32'},
        'ibuf_inserts'              => {mib => 'myIbufInserts',                 order => 31,  type => 'Counter32'},
        'ibuf_merged'               => {mib => 'myIbufMerged',                  order => 32,  type => 'Counter32'},
        'ibuf_merges'               => {mib => 'myIbufMerges',                  order => 33,  type => 'Counter32'},
        'spin_waits'                => {mib => 'mySpinWaits',                   order => 34,  type => 'Counter32'},
        'spin_rounds'               => {mib => 'mySpinRounds',                  order => 35,  type => 'Counter32'},
        'os_waits'                  => {mib => 'myOsWaits',                     order => 36,  type => 'Counter32'},
        'rows_inserted'             => {mib => 'myRowsInserted',                order => 37,  type => 'Counter32'},
        'rows_updated'              => {mib => 'myRowsUpdated',                 order => 38,  type => 'Counter32'},
        'rows_deleted'              => {mib => 'myRowsDeleted',                 order => 39,  type => 'Counter32'},
        'rows_read'                 => {mib => 'myRowsRead',                    order => 40,  type => 'Counter32'},
        'Table_locks_waited'        => {mib => 'myTableLocksWaited',            order => 41,  type => 'Counter32'},
        'Table_locks_immediate'     => {mib => 'myTableLocksImmediate',         order => 42,  type => 'Counter32'},
        'Slow_queries'              => {mib => 'mySlowQueries',                 order => 43,  type => 'Counter32'},
        'Open_files'                => {mib => 'myOpenFiles',                   order => 44,  type => 'Gauge32'},
        'Open_tables'               => {mib => 'myOpenTables',                  order => 45,  type => 'Gauge32'},
        'Opened_tables'             => {mib => 'myOpenedTables',                order => 46,  type => 'Counter32'},
        'innodb_open_files'         => {mib => 'myInnodbOpenFiles',             order => 47,  type => 'Counter32'},
        'open_files_limit'          => {mib => 'myOpenFilesLimit',              order => 48,  type => 'Counter32'},
        'table_cache'               => {mib => 'myTableCache',                  order => 49,  type => 'Counter32'},
        'Aborted_clients'           => {mib => 'myAbortedClients',              order => 50,  type => 'Counter32'},
        'Aborted_connects'          => {mib => 'myAbortedConnects',             order => 51,  type => 'Counter32'},
        'Max_used_connections'      => {mib => 'myMaxUsedConnections',          order => 52,  type => 'Counter32'},
        'Slow_launch_threads'       => {mib => 'mySlowLaunchThreads',           order => 53,  type => 'Counter32'},
        'Threads_cached'            => {mib => 'myThreadsCached',               order => 54,  type => 'Gauge32'},
        'Threads_connected'         => {mib => 'myThreadsConnected',            order => 55,  type => 'Gauge32'},
        'Threads_created'           => {mib => 'myThreadsCreated',              order => 56,  type => 'Counter32'},
        'Threads_running'           => {mib => 'myThreadsRunning',              order => 57,  type => 'Gauge32'},
        'max_connections'           => {mib => 'myMaxConnections',              order => 58,  type => 'Gauge32'},
        'thread_cache_size'         => {mib => 'myThreadCacheSize',             order => 59,  type => 'Gauge32'},
        'Connections'               => {mib => 'myConnections',                 order => 60,  type => 'Counter32'},
        'slave_running'             => {mib => 'mySlaveRunning',                order => 61,  type => 'Gauge32'},
        'slave_stopped'             => {mib => 'mySlaveStopped',                order => 62,  type => 'Gauge32'},
        'Slave_retried_transactions' => {mib => 'mySlaveRetriedTransactions',   order => 63,  type => 'Counter32'},
        'slave_lag'                  => {mib => 'mySlaveLag',                   order => 64,  type => 'Gauge32'},
        'Slave_open_temp_tables'     => {mib => 'mySlaveOpenTempTables',        order => 65,  type => 'Gauge32'},
        'Qcache_free_blocks'         => {mib => 'myQcacheFreeBlocks',           order => 66,  type => 'Gauge32'},
        'Qcache_free_memory'        => {mib => 'myQcacheFreeMemory',            order => 67,  type => 'Gauge32'},
        'Qcache_hits'               => {mib => 'myQcacheHits',                  order => 68,  type => 'Counter32'},
        'Qcache_inserts'            => {mib => 'myQcacheInserts',               order => 69,  type => 'Counter32'},
        'Qcache_lowmem_prunes'      => {mib => 'myQcacheLowmemPrunes',          order => 70,  type => 'Counter32'},
        'Qcache_not_cached'         => {mib => 'myQcacheNotCached',             order => 71,  type => 'Counter32'},
        'Qcache_queries_in_cache'   => {mib => 'myQcacheQueriesInCache',        order => 72,  type => 'Gauge32'},
        'Qcache_total_blocks'       => {mib => 'myQcacheTotalBlocks',           order => 73,  type => 'Gauge32'},
        'query_cache_size'          => {mib => 'myQueryCacheSize',              order => 74,  type => 'Counter32'},
        'Questions'                 => {mib => 'myQuestions',                   order => 75,  type => 'Counter32'},
        'Com_update'                => {mib => 'myComUpdate',                   order => 76,  type => 'Counter32'},
        'Com_insert'                => {mib => 'myComInsert',                   order => 77,  type => 'Counter32'},
        'Com_select'                => {mib => 'myComSelect',                   order => 78,  type => 'Counter32'},
        'Com_delete'                => {mib => 'myComDelete',                   order => 79,  type => 'Counter32'},
        'Com_replace'               => {mib => 'myComReplace',                  order => 80,  type => 'Counter32'},
        'Com_load'                  => {mib => 'myComLoad',                     order => 81,  type => 'Counter32'},
        'Com_update_multi'          => {mib => 'myComUpdateMulti',              order => 82,  type => 'Counter32'},
        'Com_insert_select'         => {mib => 'myComInsertSelect',             order => 83,  type => 'Counter32'},
        'Com_delete_multi'          => {mib => 'myComDeleteMulti',              order => 84,  type => 'Counter32'},
        'Com_replace_select'        => {mib => 'myComReplaceSelect',            order => 85,  type => 'Counter32'},
        'Select_full_join'          => {mib => 'mySelectFullJoin',              order => 86,  type => 'Counter32'},
        'Select_full_range_join'    => {mib => 'mySelectFullRangeJoin',         order => 87,  type => 'Counter32'},
        'Select_range'              => {mib => 'mySelectRange',                 order => 88,  type => 'Counter32'},
        'Select_range_check'        => {mib => 'mySelectRangeCheck',            order => 89,  type => 'Counter32'},
        'Select_scan'               => {mib => 'mySelectScan',                  order => 90,  type => 'Counter32'},
        'Sort_merge_passes'         => {mib => 'mySortMergePasses',             order => 91,  type => 'Counter32'},
        'Sort_range'                => {mib => 'mySortRange',                   order => 92,  type => 'Counter32'},
        'Sort_rows'                 => {mib => 'mySortRows',                    order => 93,  type => 'Counter32'},
        'Sort_scan'                 => {mib => 'mySortScan',                    order => 94,  type => 'Counter32'},
        'Created_tmp_tables'        => {mib => 'myCreatedTmpTables',            order => 95,  type => 'Counter32'},
        'Created_tmp_disk_tables'   => {mib => 'myCreatedTmpDiskTables',        order => 96,  type => 'Counter32'},
        'Created_tmp_files'         => {mib => 'myCreatedTmpFiles',             order => 97,  type => 'Counter32'},
        'Bytes_sent'                => {mib => 'myBytesSent',                   order => 98,  type => 'Counter64'},
        'Bytes_received'            => {mib => 'myBytesReceived',               order => 99,  type => 'Counter64'},
        'innodb_log_buffer_size'     => {mib => 'myInnodbLogBufferSize',        order => 100, type => 'Gauge32'},
        'unflushed_log'              => {mib => 'myUnflushedLog',               order => 101, type => 'Gauge32'},
        'log_bytes_flushed'          => {mib => 'myLogBytesFlushed',            order => 102, type => 'Counter64'},
        'log_bytes_written'          => {mib => 'myLogBytesWritten',            order => 103, type => 'Counter64'},
        'relay_log_space'            => {mib => 'myRelayLogSpace',              order => 104, type => 'Counter32'},
        'binlog_cache_size'          => {mib => 'myBinlogCacheSize',            order => 105, type => 'Gauge32'},
        'Binlog_cache_disk_use'      => {mib => 'myBinlogCacheDiskUse',         order => 106, type => 'Counter32'},
        'Binlog_cache_use'           => {mib => 'myBinlogCacheUse',             order => 107, type => 'Counter32'},
        'binary_log_space'           => {mib => 'myBinaryLogSpace',             order => 108, type => 'Counter32'},
        'State_closing_tables'       => {mib => 'myStateClosingTables',         order => 109, type => 'Gauge32'},
        'State_copying_to_tmp_table' => {mib => 'myStateCopyingToTmpTable',     order => 110, type => 'Gauge32'},
        'State_end'                 => {mib => 'myStateEnd',                    order => 111, type => 'Gauge32'},
        'State_freeing_items'       => {mib => 'myStateFreeingItems',           order => 112, type => 'Gauge32'},
        'State_init'                => {mib => 'myStateInit',                   order => 113, type => 'Gauge32'},
        'State_locked'              => {mib => 'myStateLocked',                 order => 114, type => 'Gauge32'},
        'State_login'               => {mib => 'myStateLogin',                  order => 115, type => 'Gauge32'},
        'State_preparing'           => {mib => 'myStatePreparing',              order => 116, type => 'Gauge32'},
        'State_reading_from_net'    => {mib => 'myStateReadingFromNet',         order => 117, type => 'Gauge32'},
        'State_sending_data'        => {mib => 'myStateSendingData',            order => 118, type => 'Gauge32'},
        'State_sorting_result'      => {mib => 'myStateSortingResult',          order => 119, type => 'Gauge32'},
        'State_statistics'          => {mib => 'myStateStatistics',             order => 120, type => 'Gauge32'},
        'State_updating'            => {mib => 'myStateUpdating',               order => 121, type => 'Gauge32'},
        'State_writing_to_net'      => {mib => 'myStateWritingToNet',           order => 122, type => 'Gauge32'},
        'State_none'                => {mib => 'myStateNone',                   order => 123, type => 'Gauge32'},
        'State_other'               => {mib => 'myStateOther',                  order => 124, type => 'Gauge32'},
        'additional_pool_alloc'     => {mib => 'myAdditionalPoolAlloc',         order => 125, type => 'Gauge64'},
        'total_mem_alloc'           => {mib => 'myTotalMemAlloc',               order => 126, type => 'Gauge64'},
        'hash_index_cells_total'    => {mib => 'myHashIndexCellsTotal',         order => 127, type => 'Gauge32'},
        'hash_index_cells_used'     => {mib => 'myHashIndexCellsUsed',          order => 128, type => 'Gauge32'},
        'innodb_lock_structs'       => {mib => 'myInnoDBLockStructs',           order => 129, type => 'Gauge32'},
        'innodb_lock_wait_secs'     => {mib => 'myInnoDBLockWaitSecs',          order => 130, type => 'Gauge32'},
        'innodb_tables_in_use'      => {mib => 'myInnoDBTablesInUse',           order => 131, type => 'Gauge32'},
        'innodb_locked_tables'      => {mib => 'myInnoDBLockedTables',          order => 132, type => 'Gauge32'},
        'uncheckpointed_bytes'      => {mib => 'myUncheckpointedBytes',         order => 133, type => 'Gauge32'},
        'ibuf_cell_count'           => {mib => 'myIBufCellCount',               order => 134, type => 'Gauge32'},
        'ibuf_used_cells'           => {mib => 'myIBufUsedCells',               order => 135, type => 'Gauge32'},
        'ibuf_free_cells'           => {mib => 'myIBufFreeCells',               order => 136, type => 'Gauge32'},
        'adaptive_hash_memory'      => {mib => 'myAdaptiveHashMemory',          order => 137, type => 'Gauge64'},
        'page_hash_memory'          => {mib => 'myPageHashMemory',              order => 138, type => 'Gauge64'},
        'dictionary_cache_memory'   => {mib => 'myDictionaryCacheMemory',       order => 139, type => 'Gauge64'},
        'file_system_memory'        => {mib => 'myFileSystemMemory',            order => 140, type => 'Gauge64'},
        'lock_system_memory'        => {mib => 'myLockSystemMemory',            order => 141, type => 'Gauge64'},
        'recovery_system_memory'    => {mib => 'myRecoverySystemMemory',        order => 142, type => 'Gauge64'},
        'thread_hash_memory'        => {mib => 'myThreadHashMemory',            order => 143, type => 'Gauge64'},
    },
    startoid => '.1.3.6.1.4.1.20267.200.1',
}
